Skip Navigation
search: People Opens New Window | Departments Opens New Window | Penn State Opens New Window | Web Opens New Window

Information Sciences And Technology (IST)

IST 211 Advanced Topics in Relational Database Management Systems (3) In depth coverage of: database administration, advanced Structures Query Language inquires, normalization, referential integrity; troubleshooting, tweaking; implementation dependent transactions, embedded SQL, Open Database Connectivity.

IST 211 Advanced Topics in Relational Database (3)

The course aims to develop an in depth understanding and ability to use advanced relational database management systems, specifically to understand and use advanced normalization procedures, advanced referential integrity, and advanced SQL queries in depth. Students will be exposed to the administrative aspects of robust database management systems.

This course will incorporate collaborative and action-learning experiences wherever appropriate. Emphasis will be placed on developing and practicing writing and speaking skills through application of the concepts that define the course.

Students will be evaluated by examination, exercises, quizzes, and a small project from design to implementation (including documentation).

IST 211 is the first advanced IST course for the students pursuing the Data Option in the Information Sciences and Technology Associate Degree program. Successful completion is required prior to enrollment in IST 213, 214. It may be taken simultaneously with IST 212. IST 210 is a prerequisite for IST 211.

Since this is an option requirement, only selected IST students will be enrolling; it should be offered at least once per year in class sizes of 30 or less. As enrollment growth warrants, it may require more frequent offering.


General Education: None
Diversity: None
Bachelor of Arts: None
Effective: Summer 1999
Prerequisite: IST 210

Note : Class size, frequency of offering, and evaluation methods will vary by location and instructor. For these details check the specific course syllabus.